tables = {
        "news_news": {
                "fields": (
			( "id", "INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT" ),
			( "id_media", "INT UNSIGNED" ),
			( "id_categ", "INT UNSIGNED NOT NULL DEFAULT 0" ),
			( "title", "VARCHAR ( 128 ) DEFAULT ''" ),
			( "subtitle", "VARCHAR ( 128 ) DEFAULT ''" ),
			( "id_abstract", "INT UNSIGNED NOT NULL DEFAULT 0" ),
			( "id_descr",	"INT UNSIGNED NOT NULL DEFAULT 0" ),
			( "visible",	"BOOLEAN DEFAULT 1" ),
			( "uid",	"INT UNSIGNED DEFAULT 0" ),
			( "created",	"DATETIME" ),
			( "pub_date",	"DATETIME DEFAULT '0000-00-00'" ),
			( "url", 	"VARCHAR ( 200 )" ),
			( "url_descr",	"VARCHAR ( 40 )" ),
			( "permalink",	"VARCHAR ( 40 )" ),
			( "pos",	"INT UNSIGNED DEFAULT 0" )
		),

		"indexes" : (
			"created",  "INDEX",
			"id_categ", "INDEX",
			"pub_date", "INDEX",
			"uid", 	    "INDEX",
			"id_media", "INDEX",
			"permalink", "INDEX",
			"pos",	     "INDEX"
		)
	},

	"news_count" : {
		"fields" : (
			( "id_news",  "INT UNSIGNED NOT NULL" ),
			( "kind",     "INT UNSIGNED" ),  #0 views, 1 prints, 2 comments, 3 clicks, 4 voted
			( "count",     "INT UNSIGNED DEFAULT 0" ),
		), 

		"indexes" : (
			( "id_news, kind, count", "UNIQUE" ),
			( "id_news", "INDEX" ),
			( "count",   "INDEX" )
		)
	},

	"news_categ_rel" : {
		"fields": (
			( "id_news",	"INT UNSIGNED NOT NULL" ),
			( "id_node", 	"INT UNSIGNED NOT NULL" )
		),
		"indexes" : (
			( "id_news, id_node", "UNIQUE" )
		)
	}
}

